﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$GeoByteDBConnection$" >
  <Sql>
    UPDATE IpInfo SET
      isKnown=@isKnown,iso2=@iso2,iso3=@iso3,regionId=@regionId,region=@region,regionCode=@regionCode,
      cityId=@cityId,city=@city,latitude=@latitude,longitude=@longitude,timeZone=@timeZone,certainty=@certainty,
      timeValidated=@timeValidated
    WHERE
      ipAddress=@ipAddress
  </Sql>
  <Param name="ipAddress" type="String" />
  <Param name="isKnown" type="Boolean" />
  <Param name="iso2" type="String" />
  <Param name="iso3" type="String" />
  <Param name="regionId" type="Int" />
  <Param name="region" type="String" />
  <Param name="regionCode" type="String" />
  <Param name="cityId" type="Int" />
  <Param name="city" type="String" />
  <Param name="latitude" type="String" />
  <Param name="longitude" type="String" />
  <Param name="timeZone" type="Int" />
  <Param name="certainty" type="Int" />
  <Param name="timeValidated" type="Date" />
</AdoNetDataAccess>